class CreateOrders < ActiveRecord::Migration
  def self.up
    create_table :orders do |t|
      t.string :order_num
      t.string :custmer
      t.datetime :created_at
      t.decimal :sumusd_sh
      t.decimal :sumusd_re
      t.string :payment
      t.decimal :sum_rmb
      t.string :aim_arem
      t.string :req_lang
      t.string :req_band
      t.string :req_manual
      t.string :req_charge
      t.string :delv_plan
      t.string :delv_real
      t.string :track_num
      t.string :sales
      t.decimal :profit
      t.string :status
      t.string :user

      t.timestamps
    end
  end

  def self.down
    drop_table :orders
  end
end
